package com.mhc.suzuki.dal.query;


import com.subaru.common.query.BaseCriteria;
import com.subaru.common.query.BaseQuery;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

public class CustomerQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public CustomerQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table pcl_customer
     */
         protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("customer_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(Long value) {
            addCriterion("customer_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(Long value) {
            addCriterion("customer_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria anCustomerIdGreaterThan(Long value) {
            addCriterion("customer_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("customer_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(Long value) {
            addCriterion("customer_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(Long value) {
            addCriterion("customer_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<Long> values) {
            addCriterion("customer_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<Long> values) {
            addCriterion("customer_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(Long value1, Long value2) {
            addCriterion("customer_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(Long value1, Long value2) {
            addCriterion("customer_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDate value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDate value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDate value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDate value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDate> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDate> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDate value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDate value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDate value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDate value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDate> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDate> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCompanyNoIsNull() {
            addCriterion("company_no is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNoIsNotNull() {
            addCriterion("company_no is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNoEqualTo(String value) {
            addCriterion("company_no =", value, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoNotEqualTo(String value) {
            addCriterion("company_no <>", value, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoGreaterThan(String value) {
            addCriterion("company_no >", value, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoGreaterThanOrEqualTo(String value) {
            addCriterion("company_no >=", value, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoLessThan(String value) {
            addCriterion("company_no <", value, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoLessThanOrEqualTo(String value) {
            addCriterion("company_no <=", value, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoLike(String value) {
            addCriterion("company_no like", value, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoNotLike(String value) {
            addCriterion("company_no not like", value, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoIn(List<String> values) {
            addCriterion("company_no in", values, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoNotIn(List<String> values) {
            addCriterion("company_no not in", values, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoBetween(String value1, String value2) {
            addCriterion("company_no between", value1, value2, "companyNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNoNotBetween(String value1, String value2) {
            addCriterion("company_no not between", value1, value2, "companyNo");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Long value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Long value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Long value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Long value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLike(Long value) {
            addCriterion("staff_id like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotLike(Long value) {
            addCriterion("staff_id not like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Long> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Long> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Long value1, Long value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andIdCardIsNull() {
            addCriterion("id_card is null");
            return (Criteria) this;
        }

        public Criteria andIdCardIsNotNull() {
            addCriterion("id_card is not null");
            return (Criteria) this;
        }

        public Criteria andIdCardEqualTo(String value) {
            addCriterion("id_card =", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotEqualTo(String value) {
            addCriterion("id_card <>", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardGreaterThan(String value) {
            addCriterion("id_card >", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardGreaterThanOrEqualTo(String value) {
            addCriterion("id_card >=", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLessThan(String value) {
            addCriterion("id_card <", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLessThanOrEqualTo(String value) {
            addCriterion("id_card <=", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLike(String value) {
            addCriterion("id_card like", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotLike(String value) {
            addCriterion("id_card not like", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardIn(List<String> values) {
            addCriterion("id_card in", values, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotIn(List<String> values) {
            addCriterion("id_card not in", values, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardBetween(String value1, String value2) {
            addCriterion("id_card between", value1, value2, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotBetween(String value1, String value2) {
            addCriterion("id_card not between", value1, value2, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationIsNull() {
            addCriterion("id_card_location is null");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationIsNotNull() {
            addCriterion("id_card_location is not null");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationEqualTo(String value) {
            addCriterion("id_card_location =", value, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationNotEqualTo(String value) {
            addCriterion("id_card_location <>", value, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationGreaterThan(String value) {
            addCriterion("id_card_location >", value, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationGreaterThanOrEqualTo(String value) {
            addCriterion("id_card_location >=", value, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationLessThan(String value) {
            addCriterion("id_card_location <", value, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationLessThanOrEqualTo(String value) {
            addCriterion("id_card_location <=", value, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationLike(String value) {
            addCriterion("id_card_location like", value, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationNotLike(String value) {
            addCriterion("id_card_location not like", value, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationIn(List<String> values) {
            addCriterion("id_card_location in", values, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationNotIn(List<String> values) {
            addCriterion("id_card_location not in", values, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationBetween(String value1, String value2) {
            addCriterion("id_card_location between", value1, value2, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardLocationNotBetween(String value1, String value2) {
            addCriterion("id_card_location not between", value1, value2, "idCardLocation");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrIsNull() {
            addCriterion("id_card_addr is null");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrIsNotNull() {
            addCriterion("id_card_addr is not null");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrEqualTo(String value) {
            addCriterion("id_card_addr =", value, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrNotEqualTo(String value) {
            addCriterion("id_card_addr <>", value, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrGreaterThan(String value) {
            addCriterion("id_card_addr >", value, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrGreaterThanOrEqualTo(String value) {
            addCriterion("id_card_addr >=", value, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrLessThan(String value) {
            addCriterion("id_card_addr <", value, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrLessThanOrEqualTo(String value) {
            addCriterion("id_card_addr <=", value, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrLike(String value) {
            addCriterion("id_card_addr like", value, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrNotLike(String value) {
            addCriterion("id_card_addr not like", value, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrIn(List<String> values) {
            addCriterion("id_card_addr in", values, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrNotIn(List<String> values) {
            addCriterion("id_card_addr not in", values, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrBetween(String value1, String value2) {
            addCriterion("id_card_addr between", value1, value2, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andIdCardAddrNotBetween(String value1, String value2) {
            addCriterion("id_card_addr not between", value1, value2, "idCardAddr");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(Integer value) {
            addCriterion("sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(Integer value) {
            addCriterion("sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(Integer value) {
            addCriterion("sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(Integer value) {
            addCriterion("sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(Integer value) {
            addCriterion("sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLike(Integer value) {
            addCriterion("sex like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotLike(Integer value) {
            addCriterion("sex not like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<Integer> values) {
            addCriterion("sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<Integer> values) {
            addCriterion("sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(Integer value1, Integer value2) {
            addCriterion("sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(Integer value1, Integer value2) {
            addCriterion("sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andCensusIsNull() {
            addCriterion("census is null");
            return (Criteria) this;
        }

        public Criteria andCensusIsNotNull() {
            addCriterion("census is not null");
            return (Criteria) this;
        }

        public Criteria andCensusEqualTo(String value) {
            addCriterion("census =", value, "census");
            return (Criteria) this;
        }

        public Criteria andCensusNotEqualTo(String value) {
            addCriterion("census <>", value, "census");
            return (Criteria) this;
        }

        public Criteria andCensusGreaterThan(String value) {
            addCriterion("census >", value, "census");
            return (Criteria) this;
        }

        public Criteria andCensusGreaterThanOrEqualTo(String value) {
            addCriterion("census >=", value, "census");
            return (Criteria) this;
        }

        public Criteria andCensusLessThan(String value) {
            addCriterion("census <", value, "census");
            return (Criteria) this;
        }

        public Criteria andCensusLessThanOrEqualTo(String value) {
            addCriterion("census <=", value, "census");
            return (Criteria) this;
        }

        public Criteria andCensusLike(String value) {
            addCriterion("census like", value, "census");
            return (Criteria) this;
        }

        public Criteria andCensusNotLike(String value) {
            addCriterion("census not like", value, "census");
            return (Criteria) this;
        }

        public Criteria andCensusIn(List<String> values) {
            addCriterion("census in", values, "census");
            return (Criteria) this;
        }

        public Criteria andCensusNotIn(List<String> values) {
            addCriterion("census not in", values, "census");
            return (Criteria) this;
        }

        public Criteria andCensusBetween(String value1, String value2) {
            addCriterion("census between", value1, value2, "census");
            return (Criteria) this;
        }

        public Criteria andCensusNotBetween(String value1, String value2) {
            addCriterion("census not between", value1, value2, "census");
            return (Criteria) this;
        }

        public Criteria andEducationIsNull() {
            addCriterion("education is null");
            return (Criteria) this;
        }

        public Criteria andEducationIsNotNull() {
            addCriterion("education is not null");
            return (Criteria) this;
        }

        public Criteria andEducationEqualTo(String value) {
            addCriterion("education =", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotEqualTo(String value) {
            addCriterion("education <>", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThan(String value) {
            addCriterion("education >", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThanOrEqualTo(String value) {
            addCriterion("education >=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThan(String value) {
            addCriterion("education <", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThanOrEqualTo(String value) {
            addCriterion("education <=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLike(String value) {
            addCriterion("education like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotLike(String value) {
            addCriterion("education not like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationIn(List<String> values) {
            addCriterion("education in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotIn(List<String> values) {
            addCriterion("education not in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationBetween(String value1, String value2) {
            addCriterion("education between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotBetween(String value1, String value2) {
            addCriterion("education not between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneIsNull() {
            addCriterion("mobile_phone is null");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneIsNotNull() {
            addCriterion("mobile_phone is not null");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneEqualTo(String value) {
            addCriterion("mobile_phone =", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneNotEqualTo(String value) {
            addCriterion("mobile_phone <>", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneGreaterThan(String value) {
            addCriterion("mobile_phone >", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneGreaterThanOrEqualTo(String value) {
            addCriterion("mobile_phone >=", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLessThan(String value) {
            addCriterion("mobile_phone <", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLessThanOrEqualTo(String value) {
            addCriterion("mobile_phone <=", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLike(String value) {
            addCriterion("mobile_phone like", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneNotLike(String value) {
            addCriterion("mobile_phone not like", value, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneIn(List<String> values) {
            addCriterion("mobile_phone in", values, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneNotIn(List<String> values) {
            addCriterion("mobile_phone not in", values, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneBetween(String value1, String value2) {
            addCriterion("mobile_phone between", value1, value2, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneNotBetween(String value1, String value2) {
            addCriterion("mobile_phone not between", value1, value2, "mobilePhone");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationIsNull() {
            addCriterion("mobile_phone_location is null");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationIsNotNull() {
            addCriterion("mobile_phone_location is not null");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationEqualTo(String value) {
            addCriterion("mobile_phone_location =", value, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationNotEqualTo(String value) {
            addCriterion("mobile_phone_location <>", value, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationGreaterThan(String value) {
            addCriterion("mobile_phone_location >", value, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationGreaterThanOrEqualTo(String value) {
            addCriterion("mobile_phone_location >=", value, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationLessThan(String value) {
            addCriterion("mobile_phone_location <", value, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationLessThanOrEqualTo(String value) {
            addCriterion("mobile_phone_location <=", value, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationLike(String value) {
            addCriterion("mobile_phone_location like", value, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationNotLike(String value) {
            addCriterion("mobile_phone_location not like", value, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationIn(List<String> values) {
            addCriterion("mobile_phone_location in", values, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationNotIn(List<String> values) {
            addCriterion("mobile_phone_location not in", values, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationBetween(String value1, String value2) {
            addCriterion("mobile_phone_location between", value1, value2, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andMobilePhoneLocationNotBetween(String value1, String value2) {
            addCriterion("mobile_phone_location not between", value1, value2, "mobilePhoneLocation");
            return (Criteria) this;
        }

        public Criteria andBemarriedIsNull() {
            addCriterion("bemarried is null");
            return (Criteria) this;
        }

        public Criteria andBemarriedIsNotNull() {
            addCriterion("bemarried is not null");
            return (Criteria) this;
        }

        public Criteria andBemarriedEqualTo(Integer value) {
            addCriterion("bemarried =", value, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedNotEqualTo(Integer value) {
            addCriterion("bemarried <>", value, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedGreaterThan(Integer value) {
            addCriterion("bemarried >", value, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedGreaterThanOrEqualTo(Integer value) {
            addCriterion("bemarried >=", value, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedLessThan(Integer value) {
            addCriterion("bemarried <", value, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedLessThanOrEqualTo(Integer value) {
            addCriterion("bemarried <=", value, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedLike(Integer value) {
            addCriterion("bemarried like", value, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedNotLike(Integer value) {
            addCriterion("bemarried not like", value, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedIn(List<Integer> values) {
            addCriterion("bemarried in", values, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedNotIn(List<Integer> values) {
            addCriterion("bemarried not in", values, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedBetween(Integer value1, Integer value2) {
            addCriterion("bemarried between", value1, value2, "bemarried");
            return (Criteria) this;
        }

        public Criteria andBemarriedNotBetween(Integer value1, Integer value2) {
            addCriterion("bemarried not between", value1, value2, "bemarried");
            return (Criteria) this;
        }

        public Criteria andRelationshipIsNull() {
            addCriterion("relationship is null");
            return (Criteria) this;
        }

        public Criteria andRelationshipIsNotNull() {
            addCriterion("relationship is not null");
            return (Criteria) this;
        }

        public Criteria andRelationshipEqualTo(Integer value) {
            addCriterion("relationship =", value, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipNotEqualTo(Integer value) {
            addCriterion("relationship <>", value, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipGreaterThan(Integer value) {
            addCriterion("relationship >", value, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipGreaterThanOrEqualTo(Integer value) {
            addCriterion("relationship >=", value, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipLessThan(Integer value) {
            addCriterion("relationship <", value, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipLessThanOrEqualTo(Integer value) {
            addCriterion("relationship <=", value, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipLike(Integer value) {
            addCriterion("relationship like", value, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipNotLike(Integer value) {
            addCriterion("relationship not like", value, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipIn(List<Integer> values) {
            addCriterion("relationship in", values, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipNotIn(List<Integer> values) {
            addCriterion("relationship not in", values, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipBetween(Integer value1, Integer value2) {
            addCriterion("relationship between", value1, value2, "relationship");
            return (Criteria) this;
        }

        public Criteria andRelationshipNotBetween(Integer value1, Integer value2) {
            addCriterion("relationship not between", value1, value2, "relationship");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrIsNull() {
            addCriterion("residential_addr is null");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrIsNotNull() {
            addCriterion("residential_addr is not null");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrEqualTo(String value) {
            addCriterion("residential_addr =", value, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrNotEqualTo(String value) {
            addCriterion("residential_addr <>", value, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrGreaterThan(String value) {
            addCriterion("residential_addr >", value, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrGreaterThanOrEqualTo(String value) {
            addCriterion("residential_addr >=", value, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrLessThan(String value) {
            addCriterion("residential_addr <", value, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrLessThanOrEqualTo(String value) {
            addCriterion("residential_addr <=", value, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrLike(String value) {
            addCriterion("residential_addr like", value, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrNotLike(String value) {
            addCriterion("residential_addr not like", value, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrIn(List<String> values) {
            addCriterion("residential_addr in", values, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrNotIn(List<String> values) {
            addCriterion("residential_addr not in", values, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrBetween(String value1, String value2) {
            addCriterion("residential_addr between", value1, value2, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andResidentialAddrNotBetween(String value1, String value2) {
            addCriterion("residential_addr not between", value1, value2, "residentialAddr");
            return (Criteria) this;
        }

        public Criteria andOrgNameIsNull() {
            addCriterion("org_name is null");
            return (Criteria) this;
        }

        public Criteria andOrgNameIsNotNull() {
            addCriterion("org_name is not null");
            return (Criteria) this;
        }

        public Criteria andOrgNameEqualTo(String value) {
            addCriterion("org_name =", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotEqualTo(String value) {
            addCriterion("org_name <>", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameGreaterThan(String value) {
            addCriterion("org_name >", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameGreaterThanOrEqualTo(String value) {
            addCriterion("org_name >=", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLessThan(String value) {
            addCriterion("org_name <", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLessThanOrEqualTo(String value) {
            addCriterion("org_name <=", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLike(String value) {
            addCriterion("org_name like", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotLike(String value) {
            addCriterion("org_name not like", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameIn(List<String> values) {
            addCriterion("org_name in", values, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotIn(List<String> values) {
            addCriterion("org_name not in", values, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameBetween(String value1, String value2) {
            addCriterion("org_name between", value1, value2, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotBetween(String value1, String value2) {
            addCriterion("org_name not between", value1, value2, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgTypeIsNull() {
            addCriterion("org_type is null");
            return (Criteria) this;
        }

        public Criteria andOrgTypeIsNotNull() {
            addCriterion("org_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrgTypeEqualTo(Integer value) {
            addCriterion("org_type =", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeNotEqualTo(Integer value) {
            addCriterion("org_type <>", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeGreaterThan(Integer value) {
            addCriterion("org_type >", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("org_type >=", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeLessThan(Integer value) {
            addCriterion("org_type <", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeLessThanOrEqualTo(Integer value) {
            addCriterion("org_type <=", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeLike(Integer value) {
            addCriterion("org_type like", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeNotLike(Integer value) {
            addCriterion("org_type not like", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeIn(List<Integer> values) {
            addCriterion("org_type in", values, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeNotIn(List<Integer> values) {
            addCriterion("org_type not in", values, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeBetween(Integer value1, Integer value2) {
            addCriterion("org_type between", value1, value2, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("org_type not between", value1, value2, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgAddrIsNull() {
            addCriterion("org_addr is null");
            return (Criteria) this;
        }

        public Criteria andOrgAddrIsNotNull() {
            addCriterion("org_addr is not null");
            return (Criteria) this;
        }

        public Criteria andOrgAddrEqualTo(String value) {
            addCriterion("org_addr =", value, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrNotEqualTo(String value) {
            addCriterion("org_addr <>", value, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrGreaterThan(String value) {
            addCriterion("org_addr >", value, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrGreaterThanOrEqualTo(String value) {
            addCriterion("org_addr >=", value, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrLessThan(String value) {
            addCriterion("org_addr <", value, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrLessThanOrEqualTo(String value) {
            addCriterion("org_addr <=", value, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrLike(String value) {
            addCriterion("org_addr like", value, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrNotLike(String value) {
            addCriterion("org_addr not like", value, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrIn(List<String> values) {
            addCriterion("org_addr in", values, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrNotIn(List<String> values) {
            addCriterion("org_addr not in", values, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrBetween(String value1, String value2) {
            addCriterion("org_addr between", value1, value2, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgAddrNotBetween(String value1, String value2) {
            addCriterion("org_addr not between", value1, value2, "orgAddr");
            return (Criteria) this;
        }

        public Criteria andOrgTelIsNull() {
            addCriterion("org_tel is null");
            return (Criteria) this;
        }

        public Criteria andOrgTelIsNotNull() {
            addCriterion("org_tel is not null");
            return (Criteria) this;
        }

        public Criteria andOrgTelEqualTo(String value) {
            addCriterion("org_tel =", value, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelNotEqualTo(String value) {
            addCriterion("org_tel <>", value, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelGreaterThan(String value) {
            addCriterion("org_tel >", value, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelGreaterThanOrEqualTo(String value) {
            addCriterion("org_tel >=", value, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelLessThan(String value) {
            addCriterion("org_tel <", value, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelLessThanOrEqualTo(String value) {
            addCriterion("org_tel <=", value, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelLike(String value) {
            addCriterion("org_tel like", value, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelNotLike(String value) {
            addCriterion("org_tel not like", value, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelIn(List<String> values) {
            addCriterion("org_tel in", values, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelNotIn(List<String> values) {
            addCriterion("org_tel not in", values, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelBetween(String value1, String value2) {
            addCriterion("org_tel between", value1, value2, "orgTel");
            return (Criteria) this;
        }

        public Criteria andOrgTelNotBetween(String value1, String value2) {
            addCriterion("org_tel not between", value1, value2, "orgTel");
            return (Criteria) this;
        }

        public Criteria andJobIsNull() {
            addCriterion("job is null");
            return (Criteria) this;
        }

        public Criteria andJobIsNotNull() {
            addCriterion("job is not null");
            return (Criteria) this;
        }

        public Criteria andJobEqualTo(String value) {
            addCriterion("job =", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobNotEqualTo(String value) {
            addCriterion("job <>", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobGreaterThan(String value) {
            addCriterion("job >", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobGreaterThanOrEqualTo(String value) {
            addCriterion("job >=", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobLessThan(String value) {
            addCriterion("job <", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobLessThanOrEqualTo(String value) {
            addCriterion("job <=", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobLike(String value) {
            addCriterion("job like", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobNotLike(String value) {
            addCriterion("job not like", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobIn(List<String> values) {
            addCriterion("job in", values, "job");
            return (Criteria) this;
        }

        public Criteria andJobNotIn(List<String> values) {
            addCriterion("job not in", values, "job");
            return (Criteria) this;
        }

        public Criteria andJobBetween(String value1, String value2) {
            addCriterion("job between", value1, value2, "job");
            return (Criteria) this;
        }

        public Criteria andJobNotBetween(String value1, String value2) {
            addCriterion("job not between", value1, value2, "job");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeIsNull() {
            addCriterion("month_income is null");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeIsNotNull() {
            addCriterion("month_income is not null");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeEqualTo(java.math.BigDecimal value) {
            addCriterion("month_income =", value, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeNotEqualTo(java.math.BigDecimal value) {
            addCriterion("month_income <>", value, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeGreaterThan(java.math.BigDecimal value) {
            addCriterion("month_income >", value, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("month_income >=", value, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeLessThan(java.math.BigDecimal value) {
            addCriterion("month_income <", value, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("month_income <=", value, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeLike(java.math.BigDecimal value) {
            addCriterion("month_income like", value, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeNotLike(java.math.BigDecimal value) {
            addCriterion("month_income not like", value, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeIn(List<java.math.BigDecimal> values) {
            addCriterion("month_income in", values, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeNotIn(List<java.math.BigDecimal> values) {
            addCriterion("month_income not in", values, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("month_income between", value1, value2, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andMonthIncomeNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("month_income not between", value1, value2, "monthIncome");
            return (Criteria) this;
        }

        public Criteria andWorkAgeIsNull() {
            addCriterion("work_age is null");
            return (Criteria) this;
        }

        public Criteria andWorkAgeIsNotNull() {
            addCriterion("work_age is not null");
            return (Criteria) this;
        }

        public Criteria andWorkAgeEqualTo(Integer value) {
            addCriterion("work_age =", value, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeNotEqualTo(Integer value) {
            addCriterion("work_age <>", value, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeGreaterThan(Integer value) {
            addCriterion("work_age >", value, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeGreaterThanOrEqualTo(Integer value) {
            addCriterion("work_age >=", value, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeLessThan(Integer value) {
            addCriterion("work_age <", value, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeLessThanOrEqualTo(Integer value) {
            addCriterion("work_age <=", value, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeLike(Integer value) {
            addCriterion("work_age like", value, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeNotLike(Integer value) {
            addCriterion("work_age not like", value, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeIn(List<Integer> values) {
            addCriterion("work_age in", values, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeNotIn(List<Integer> values) {
            addCriterion("work_age not in", values, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeBetween(Integer value1, Integer value2) {
            addCriterion("work_age between", value1, value2, "workAge");
            return (Criteria) this;
        }

        public Criteria andWorkAgeNotBetween(Integer value1, Integer value2) {
            addCriterion("work_age not between", value1, value2, "workAge");
            return (Criteria) this;
        }

        public Criteria andHouseIdIsNull() {
            addCriterion("house_id is null");
            return (Criteria) this;
        }

        public Criteria andHouseIdIsNotNull() {
            addCriterion("house_id is not null");
            return (Criteria) this;
        }

        public Criteria andHouseIdEqualTo(Long value) {
            addCriterion("house_id =", value, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdNotEqualTo(Long value) {
            addCriterion("house_id <>", value, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdGreaterThan(Long value) {
            addCriterion("house_id >", value, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdGreaterThanOrEqualTo(Long value) {
            addCriterion("house_id >=", value, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdLessThan(Long value) {
            addCriterion("house_id <", value, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdLessThanOrEqualTo(Long value) {
            addCriterion("house_id <=", value, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdLike(Long value) {
            addCriterion("house_id like", value, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdNotLike(Long value) {
            addCriterion("house_id not like", value, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdIn(List<Long> values) {
            addCriterion("house_id in", values, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdNotIn(List<Long> values) {
            addCriterion("house_id not in", values, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdBetween(Long value1, Long value2) {
            addCriterion("house_id between", value1, value2, "houseId");
            return (Criteria) this;
        }

        public Criteria andHouseIdNotBetween(Long value1, Long value2) {
            addCriterion("house_id not between", value1, value2, "houseId");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table pcl_customer
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}